# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年12月14日
"""
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

sns.set_style('darkgrid')
plt.rcParams['font.sans-serif'] = ['SimHei']
df1 = pd.read_excel('../source/data - 5.7.4.3.xls', sheet_name='sheet2')
sns.barplot(x='学号', y='得分', hue='学科', data=df1)
plt.show()
print(df1.head())
